package org.dromara.yuanshidian.domain.bo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class Ab04ExcelDTO {

    @ExcelProperty(value = "统筹区编码(必填)", index = 0) // index对应Excel列索引（从0开始）
    private String aaa027;

    @ExcelProperty(value = "单位编码(必填)", index = 1)
    private String dw01;

    @ExcelProperty(value = "单位名称(必填)", index = 2)
    private String dw02;

    @ExcelProperty(value = "个人帐号(必填)", index = 3)
    private String gr03;

    @ExcelProperty(value = "姓名(必填)", index = 4)
    private String gr04;

    @ExcelProperty(value = "身份证号码(必填)", index = 5)
    private String gr02;

    @ExcelProperty(value = "状态(1=在职,2=转入)(必填)", index = 6)
    private String grmx01;

    @ExcelProperty(value = "缴费月度(必填)", index = 7)
    private String grmx02;

    @ExcelProperty(value = "缴费时间(必填)", index = 8)
    @DateTimeFormat("yyyy-MM-dd") // Excel中日期格式
    private Date grmx03;

    @ExcelProperty(value = "上年工资(必填)", index = 9)
    private BigDecimal gr18;

    @ExcelProperty(value = "个人缴费基数(必填)", index = 10)
    private Long gr19;

    @ExcelProperty(value = "个人缴费额(必填)", index = 11)
    private BigDecimal gr20;

    @ExcelProperty(value = "单位划转额(必填)", index = 12)
    private BigDecimal grmx04;

    @ExcelProperty(value = "单位代缴额(必填)", index = 13)
    private BigDecimal grmx05;

    @ExcelProperty(value = "单位平均工资(必填)", index = 14)
    private Long dw14;

    @ExcelProperty(value = "单位缴费比例(必填)", index = 15)
    private Long cs03;

    @ExcelProperty(value = "单位基数算法(必填)", index = 16)
    private String dw68;

    @ExcelProperty(value = "计息年度(必填)", index = 17)
    private String grjx01;

    @ExcelProperty(value = "缴费开始时间(必填)", index = 18)
    @DateTimeFormat("yyyy-MM-dd")
    private Date jfStarttime;

    @ExcelProperty(value = "缴费截止时间(必填)", index = 19)
    @DateTimeFormat("yyyy-MM-dd")
    private Date jfEndtime;

    @ExcelProperty(value = "个人编号(必填)", index = 20)
    private String gr01;

    @ExcelProperty(value = "结算开始月份(必填)", index = 21)
    private String jsStartmonth;

    @ExcelProperty(value = "结算截至月份(必填)", index = 22)
    private String jsEndmonth;

    @ExcelProperty(value = "缴费月数(必填)", index = 23)
    private Long jfPaymentmonths;

    @ExcelProperty(value = "个人缴费本息(必填)", index = 24)
    private BigDecimal grjfbx;

    @ExcelProperty(value = "个人账户本息(必填)", index = 25)
    private BigDecimal grzhbx;

    @ExcelProperty(value = "缴费时身份编制(必填)", index = 26)
    private String jfssfbz;
}
